package com.mes.controller;

import com.yy.base.common.dao.Dao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import java.util.List;
import java.util.Map;

@Controller
@RequestMapping("screen_kb_data")
public class ScreenKbDataController {

    @Autowired
    private Dao dao;

    //获取看板数据
    @RequestMapping("getServerData")
    @ResponseBody
    public List<Map<String,Object>> getServerData(String name){
        String sql = "SELECT KB.* FROM Emes_SCREEN_KB_DATA KB,AD_ORG AO WHERE KB.AD_ORG_ID=AO.AD_ORG_ID AND AO.NAME=? ORDER BY Emes_SCREEN_KB_DATA_ID ASC";
        
        return dao.query(sql,name);
    }
}
